package com.bkgy.modular.hotcoldedgeanalyse.entity;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import lombok.Data;

@Data
public class ColdEdgeSame {
    //cold
    @ExcelProperty("热轧卷号")
    @ColumnWidth(20)
    private String hot_coil_id;

    @ExcelProperty("冷轧卷号")
    @ColumnWidth(20)
    private String cold_coil_id;

    @ExcelProperty("常化卷号")
    @ColumnWidth(20)
    private String entid;


    @ExcelProperty("创建时间")
    @ColumnWidth(20)
    @DateTimeFormat("yyyy-MM-dd HH:mm:ss")
    private String createtime;


    @ExcelProperty("钢种")
    @ColumnWidth(20)
    private String steel_grade;


    @ExcelProperty("热轧卷宽度分档代码")
    @ColumnWidth(20)
    private Double width_trg_interval;


    @ExcelProperty("热轧卷厚度分档代码")
    @ColumnWidth(20)
    private Double thick_trg_interval;


    @ExcelProperty("酸轧S1机架轧制力偏差平均值")
    @ColumnWidth(20)
    private Double force1_dev_ave;


    @ExcelProperty("酸轧S1机架轧制力偏差标准差")
    @ColumnWidth(20)
    private Double force1_dev_stddev;


    @ExcelProperty("酸轧S1机架轧制力偏差极差")
    @ColumnWidth(20)
    private Double force1_dev_range;


    @ExcelProperty("酸轧S2机架轧制力偏差平均值")
    @ColumnWidth(20)
    private Double force2_dev_ave;


    @ExcelProperty("酸轧S2机架轧制力偏差标准差")
    @ColumnWidth(20)
    private Double force2_dev_stddev;


    @ExcelProperty("酸轧S2机架轧制力偏差极差")
    @ColumnWidth(20)
    private Double force2_dev_range;


    @ExcelProperty("酸轧S3机架轧制力偏差平均值")
    @ColumnWidth(20)
    private Double force3_dev_ave;


    @ExcelProperty("酸轧S3机架轧制力偏差标准差")
    @ColumnWidth(20)
    private Double force3_dev_stddev;


    @ExcelProperty("酸轧S3机架轧制力偏差极差")
    @ColumnWidth(20)
    private Double force3_dev_range;


    @ExcelProperty("酸轧S3机架轧制力偏差平均值")
    @ColumnWidth(20)
    private Double force4_dev_ave;


    @ExcelProperty("酸轧S3机架轧制力偏差标准差")
    @ColumnWidth(20)
    private Double force4_dev_stddev;


    @ExcelProperty("酸轧S3机架轧制力偏差极差")
    @ColumnWidth(20)
    private Double force4_dev_range;


    @ExcelProperty("1#工作辊窜辊平均值")
    @ColumnWidth(20)
    private Double s1_wr_shifting_ave;


    @ExcelProperty("1#工作辊窜辊标准差")
    @ColumnWidth(20)
    private Double s1_wr_shifting_stddev;


    @ExcelProperty("1#工作辊窜辊极差")
    @ColumnWidth(20)
    private Double s1_wr_shifting_range;


    @ExcelProperty("2#工作辊窜辊平均值")
    @ColumnWidth(20)
    private Double s2_wr_shifting_ave;


    @ExcelProperty("2#工作辊窜辊标准差")
    @ColumnWidth(20)
    private Double s2_wr_shifting_stddev;


    @ExcelProperty("2#工作辊窜辊极差")
    @ColumnWidth(20)
    private Double s2_wr_shifting_range;


    @ExcelProperty("1#中间辊窜辊平均值")
    @ColumnWidth(20)
    private Double s1_mr_shifting_ave;


    @ExcelProperty("1#中间辊窜辊标准差")
    @ColumnWidth(20)
    private Double s1_mr_shifting_stddev;


    @ExcelProperty("1#中间辊窜辊极差")
    @ColumnWidth(20)
    private Double s1_mr_shifting_range;


    @ExcelProperty("2#中间辊窜辊平均值")
    @ColumnWidth(20)
    private Double s2_mr_shifting_ave;


    @ExcelProperty("2#中间辊窜辊标准差")
    @ColumnWidth(20)
    private Double s2_mr_shifting_stddev;


    @ExcelProperty("2#中间辊窜辊极差")
    @ColumnWidth(20)
    private Double s2_mr_shifting_range;


    @ExcelProperty("3#中间辊窜辊平均值")
    @ColumnWidth(20)
    private Double s3_mr_shifting_ave;


    @ExcelProperty("3#中间辊窜辊标准差")
    @ColumnWidth(20)
    private Double s3_mr_shifting_stddev;


    @ExcelProperty("3#中间辊窜辊极差")
    @ColumnWidth(20)
    private Double s3_mr_shifting_range;


    @ExcelProperty("4#中间辊窜辊平均值")
    @ColumnWidth(20)
    private Double s4_mr_shifting_ave;


    @ExcelProperty("4#中间辊窜辊标准差")
    @ColumnWidth(20)
    private Double s4_mr_shifting_stddev;


    @ExcelProperty("4#中间辊窜辊极差")
    @ColumnWidth(20)
    private Double s4_mr_shifting_range;


    @ExcelProperty("1#工作辊弯辊平均值")
    @ColumnWidth(20)
    private Double s1_wr_bend_ave;


    @ExcelProperty("1#工作辊弯辊标准差")
    @ColumnWidth(20)
    private Double s1_wr_bend_stddev;


    @ExcelProperty("1#工作辊弯辊极差")
    @ColumnWidth(20)
    private Double s1_wr_bend_range;


    @ExcelProperty("2#工作辊弯辊平均值")
    @ColumnWidth(20)
    private Double s2_wr_bend_ave;


    @ExcelProperty("2#工作辊弯辊标准差")
    @ColumnWidth(20)
    private Double s2_wr_bend_stddev;


    @ExcelProperty("2#工作辊弯辊极差")
    @ColumnWidth(20)
    private Double s2_wr_bend_range;


    @ExcelProperty("3#工作辊弯辊平均值")
    @ColumnWidth(20)
    private Double s3_wr_bend_ave;


    @ExcelProperty("3#工作辊弯辊标准差")
    @ColumnWidth(20)
    private Double s3_wr_bend_stddev;


    @ExcelProperty("3#工作辊弯辊极差")
    @ColumnWidth(20)
    private Double s3_wr_bend_range;


    @ExcelProperty("4#工作辊弯辊平均值")
    @ColumnWidth(20)
    private Double s4_wr_bend_ave;


    @ExcelProperty("4#工作辊弯辊标准差")
    @ColumnWidth(20)
    private Double s4_wr_bend_stddev;


    @ExcelProperty("4#工作辊弯辊极差")
    @ColumnWidth(20)
    private Double s4_wr_bend_range;


    @ExcelProperty("1#中间辊弯辊平均值")
    @ColumnWidth(20)
    private Double s1_mr_bend_ave;


    @ExcelProperty("1#中间辊弯辊标准差")
    @ColumnWidth(20)
    private Double s1_mr_bend_stddev;


    @ExcelProperty("1#中间辊弯辊极差")
    @ColumnWidth(20)
    private Double s1_mr_bend_range;


    @ExcelProperty("2#中间辊弯辊平均值")
    @ColumnWidth(20)
    private Double s2_mr_bend_ave;


    @ExcelProperty("2#中间辊弯辊标准差")
    @ColumnWidth(20)
    private Double s2_mr_bend_stddev;


    @ExcelProperty("2#中间辊弯辊极差")
    @ColumnWidth(20)
    private Double s2_mr_bend_range;


    @ExcelProperty("3#中间辊弯辊平均值")
    @ColumnWidth(20)
    private Double s3_mr_bend_ave;


    @ExcelProperty("3#中间辊弯辊标准差")
    @ColumnWidth(20)
    private Double s3_mr_bend_stddev;


    @ExcelProperty("3#中间辊弯辊极差")
    @ColumnWidth(20)
    private Double s3_mr_bend_range;


    @ExcelProperty("4#中间辊弯辊平均值")
    @ColumnWidth(20)
    private Double s4_mr_bend_ave;


    @ExcelProperty("4#中间辊弯辊标准差")
    @ColumnWidth(20)
    private Double s4_mr_bend_stddev;


    @ExcelProperty("4#中间辊弯辊极差")
    @ColumnWidth(20)
    private Double s4_mr_bend_range;


    @ExcelProperty("1#工作辊轧制公里数")
    @ColumnWidth(20)
    private Double s1_wr_rolling_km;


    @ExcelProperty("2#工作辊轧制公里数")
    @ColumnWidth(20)
    private Double s2_wr_rolling_km;


    @ExcelProperty("3#工作辊轧制公里数")
    @ColumnWidth(20)
    private Double s3_wr_rolling_km;


    @ExcelProperty("4#工作辊轧制公里数")
    @ColumnWidth(20)
    private Double s4_wr_rolling_km;


    @ExcelProperty("1#入口厚度")
    @ColumnWidth(20)
    private Double s1_en_thk;


    @ExcelProperty("1#出口厚度")
    @ColumnWidth(20)
    private Double s1_ex_thk;


    @ExcelProperty("4#入口厚度")
    @ColumnWidth(20)
    private Double s4_en_thk;


    @ExcelProperty("4#出口厚度")
    @ColumnWidth(20)
    private Double s4_ex_thk;


    @ExcelProperty("4机架出口速度平均值")
    @ColumnWidth(20)
    private Double speed_ave;


    @ExcelProperty("4机架出口速度标准差")
    @ColumnWidth(20)
    private Double speed_ave_stddev;


    @ExcelProperty("4机架出口速度极差")
    @ColumnWidth(20)
    private Double speed_ave_range;


    @ExcelProperty("1#机架两侧轧制力差平均值")
    @ColumnWidth(20)
    private Double s1_force_act_diff_ave;


    @ExcelProperty("1#机架两侧轧制力差标准差")
    @ColumnWidth(20)
    private Double s1_force_act_diff_stsdev;


    @ExcelProperty("1#机架两侧轧制力差极差")
    @ColumnWidth(20)
    private Double s1_force_act_diff_range;


    @ExcelProperty("2#机架两侧轧制力差平均值")
    @ColumnWidth(20)
    private Double s2_force_act_diff_ave;


    @ExcelProperty("2#机架两侧轧制力差标准差")
    @ColumnWidth(20)
    private Double s2_force_act_diff_stsdev;


    @ExcelProperty("2#机架两侧轧制力差极差")
    @ColumnWidth(20)
    private Double s2_force_act_diff_range;


    @ExcelProperty("3#机架两侧轧制力差平均值")
    @ColumnWidth(20)
    private Double s3_force_act_diff_ave;


    @ExcelProperty("3#机架两侧轧制力差标准差")
    @ColumnWidth(20)
    private Double s3_force_act_diff_stsdev;


    @ExcelProperty("3#机架两侧轧制力差极差")
    @ColumnWidth(20)
    private Double s3_force_act_diff_range;


    @ExcelProperty("4#机架两侧轧制力差平均值")
    @ColumnWidth(20)
    private Double s4_force_act_diff_ave;


    @ExcelProperty("4#机架两侧轧制力差标准差")
    @ColumnWidth(20)
    private Double s4_force_act_diff_stsdev;


    @ExcelProperty("4#机架两侧轧制力差极差")
    @ColumnWidth(20)
    private Double s4_force_act_diff_range;


    @ExcelProperty("1#机架前单位张力平均值")
    @ColumnWidth(20)
    private Double s01_unit_tension_ave;


    @ExcelProperty("1#机架前单位张力标准差")
    @ColumnWidth(20)
    private Double s01_unit_tension_stddev;


    @ExcelProperty("1#机架前单位张力极差")
    @ColumnWidth(20)
    private Double s01_unit_tension_range;


    @ExcelProperty("1#2#机架间单位张力平均值")
    @ColumnWidth(20)
    private Double s12_unit_tension_ave;


    @ExcelProperty("1#2#机架间单位张力标准差")
    @ColumnWidth(20)
    private Double s12_unit_tension_stddev;


    @ExcelProperty("1#2#机架间单位张力极差")
    @ColumnWidth(20)
    private Double s12_unit_tension_range;


    @ExcelProperty("2#3#机架间单位张力平均值")
    @ColumnWidth(20)
    private Double s23_unit_tension_ave;


    @ExcelProperty("2#3#机架间单位张力标准差")
    @ColumnWidth(20)
    private Double s23_unit_tension_stddev;


    @ExcelProperty("2#3#机架间单位张力极差")
    @ColumnWidth(20)
    private Double s23_unit_tension_range;


    @ExcelProperty("3#4#机架间单位张力平均值")
    @ColumnWidth(20)
    private Double s34_unit_tension_ave;


    @ExcelProperty("3#4#机架间单位张力标准差")
    @ColumnWidth(20)
    private Double s34_unit_tension_stddev;


    @ExcelProperty("3#4#机架间单位张力极差")
    @ColumnWidth(20)
    private Double s34_unit_tension_range;


    @ExcelProperty("4机架出口单位张力平均值")
    @ColumnWidth(20)
    private Double s4_ex_unit_tension_ave;


    @ExcelProperty("4机架出口单位张力标准差")
    @ColumnWidth(20)
    private Double s4_ex_unit_tension_stddev;


    @ExcelProperty("4机架出口单位张力极差")
    @ColumnWidth(20)
    private Double s4_ex_unit_tension_range;


    @ExcelProperty("1#机架前两侧张力差平均值")
    @ColumnWidth(20)
    private Double s01_tension_diff_ave;


    @ExcelProperty("1#机架前两侧张力差标准差")
    @ColumnWidth(20)
    private Double s01_tension_diff_stddev;


    @ExcelProperty("1#机架前两侧张力差极差")
    @ColumnWidth(20)
    private Double s01_tension_diff_range;


    @ExcelProperty("1#2#机架间两侧张力差平均值")
    @ColumnWidth(20)
    private Double s12_tension_diff_ave;


    @ExcelProperty("1#2#机架间两侧张力差标准差")
    @ColumnWidth(20)
    private Double s12_tension_diff_stddev;


    @ExcelProperty("1#2#机架间两侧张力差极差")
    @ColumnWidth(20)
    private Double s12_tension_diff_range;


    @ExcelProperty("2#3#机架间两侧张力差平均值")
    @ColumnWidth(20)
    private Double s23_tension_diff_ave;


    @ExcelProperty("2#3#机架间两侧张力差标准差")
    @ColumnWidth(20)
    private Double s23_tension_diff_stddev;


    @ExcelProperty("2#3#机架间两侧张力差极差")
    @ColumnWidth(20)
    private Double s23_tension_diff_range;


    @ExcelProperty("3#4#机架间两侧张力差平均值")
    @ColumnWidth(20)
    private Double s34_tension_diff_ave;


    @ExcelProperty("3#4#机架间两侧张力差标准差")
    @ColumnWidth(20)
    private Double s34_tension_diff_stddev;


    @ExcelProperty("3#4#机架间两侧张力差极差")
    @ColumnWidth(20)
    private Double s34_tension_diff_range;


    @ExcelProperty("4机架出口张力偏差平均值")
    @ColumnWidth(20)
    private Double s4_ex_tension_diff_ave;


    @ExcelProperty("4机架出口张力偏差标准差")
    @ColumnWidth(20)
    private Double s4_ex_tension_diff_stddev;


    @ExcelProperty("4机架出口张力偏差极差")
    @ColumnWidth(20)
    private Double s4_ex_tension_diff_range;


    @ExcelProperty("1机架工作侧辊缝实际平均值")
    @ColumnWidth(20)
    private Double s1_ws_rollgap_act_ave;


    @ExcelProperty("1机架工作侧辊缝实际标准差")
    @ColumnWidth(20)
    private Double s1_ws_rollgap_act_stddev;


    @ExcelProperty("1机架工作侧辊缝实际极差")
    @ColumnWidth(20)
    private Double s1_ws_rollgap_act_range;


    @ExcelProperty("1机架传动侧辊缝实际平均值")
    @ColumnWidth(20)
    private Double s1_ds_rollgap_act_ave;


    @ExcelProperty("1机架传动侧辊缝实际标准差")
    @ColumnWidth(20)
    private Double s1_ds_rollgap_act_stddev;


    @ExcelProperty("1机架传动侧辊缝实际极差")
    @ColumnWidth(20)
    private Double s1_ds_rollgap_act_range;


    @ExcelProperty("2机架工作侧辊缝实际平均值")
    @ColumnWidth(20)
    private Double s2_ws_rollgap_act_ave;


    @ExcelProperty("2机架工作侧辊缝实际标准差")
    @ColumnWidth(20)
    private Double s2_ws_rollgap_act_stddev;


    @ExcelProperty("2机架工作侧辊缝实际极差")
    @ColumnWidth(20)
    private Double s2_ws_rollgap_act_range;


    @ExcelProperty("2机架传动侧辊缝实际平均值")
    @ColumnWidth(20)
    private Double s2_ds_rollgap_act_ave;


    @ExcelProperty("2机架传动侧辊缝实际标准差")
    @ColumnWidth(20)
    private Double s2_ds_rollgap_act_stddev;


    @ExcelProperty("2机架传动侧辊缝实际极差")
    @ColumnWidth(20)
    private Double s2_ds_rollgap_act_range;


    @ExcelProperty("3机架工作侧辊缝实际平均值")
    @ColumnWidth(20)
    private Double s3_ws_rollgap_act_ave;


    @ExcelProperty("3机架工作侧辊缝实际标准差")
    @ColumnWidth(20)
    private Double s3_ws_rollgap_act_stddev;


    @ExcelProperty("3机架工作侧辊缝实际极差")
    @ColumnWidth(20)
    private Double s3_ws_rollgap_act_range;


    @ExcelProperty("3机架传动侧辊缝实际平均值")
    @ColumnWidth(20)
    private Double s3_ds_rollgap_act_ave;


    @ExcelProperty("3机架传动侧辊缝实际标准差")
    @ColumnWidth(20)
    private Double s3_ds_rollgap_act_stddev;


    @ExcelProperty("3机架传动侧辊缝实际极差")
    @ColumnWidth(20)
    private Double s3_ds_rollgap_act_range;


    @ExcelProperty("4机架工作侧辊缝实际平均值")
    @ColumnWidth(20)
    private Double s4_ws_rollgap_act_ave;


    @ExcelProperty("4机架工作侧辊缝实际标准差")
    @ColumnWidth(20)
    private Double s4_ws_rollgap_act_stddev;


    @ExcelProperty("4机架工作侧辊缝实际极差")
    @ColumnWidth(20)
    private Double s4_ws_rollgap_act_range;


    @ExcelProperty("4机架传动侧辊缝实际平均值")
    @ColumnWidth(20)
    private Double s4_ds_rollgap_act_ave;


    @ExcelProperty("4机架传动侧辊缝实际标准差")
    @ColumnWidth(20)
    private Double s4_ds_rollgap_act_stddev;


    @ExcelProperty("4机架传动侧辊缝实际极差")
    @ColumnWidth(20)
    private Double s4_ds_rollgap_act_range;


    @ExcelProperty("1机架调平值实际平均值")
    @ColumnWidth(20)
    private Double s1_leveling_act_ave;


    @ExcelProperty("1机架调平值实际标准差")
    @ColumnWidth(20)
    private Double s1_leveling_act_stddev;


    @ExcelProperty("1机架调平值实际极差")
    @ColumnWidth(20)
    private Double s1_leveling_act_range;


    @ExcelProperty("2机架调平值实际平均值")
    @ColumnWidth(20)
    private Double s2_leveling_act_ave;


    @ExcelProperty("2机架调平值实际标准差")
    @ColumnWidth(20)
    private Double s2_leveling_act_stddev;


    @ExcelProperty("2机架调平值实际极差")
    @ColumnWidth(20)
    private Double s2_leveling_act_range;


    @ExcelProperty("3机架调平值实际平均值")
    @ColumnWidth(20)
    private Double s3_leveling_act_ave;


    @ExcelProperty("3机架调平值实际标准差")
    @ColumnWidth(20)
    private Double s3_leveling_act_stddev;


    @ExcelProperty("3机架调平值实际极差")
    @ColumnWidth(20)
    private Double s3_leveling_act_range;


    @ExcelProperty("4机架调平值实际平均值")
    @ColumnWidth(20)
    private Double s4_leveling_act_ave;


    @ExcelProperty("4机架调平值实际标准差")
    @ColumnWidth(20)
    private Double s4_leveling_act_stddev;


    @ExcelProperty("4机架调平值实际极差")
    @ColumnWidth(20)
    private Double s4_leveling_act_range;


    @ExcelProperty("1机架工作辊辊径")
    @ColumnWidth(20)
    private Double s1_wr_dia;


    @ExcelProperty("2机架工作辊辊径")
    @ColumnWidth(20)
    private Double s2_wr_dia;


    @ExcelProperty("3机架工作辊辊径")
    @ColumnWidth(20)
    private Double s3_wr_dia;


    @ExcelProperty("4机架工作辊辊径")
    @ColumnWidth(20)
    private Double s4_wr_dia;


    @ExcelProperty("生产时间")
    @ColumnWidth(20)
    @DateTimeFormat("yyyy-MM-dd HH:mm:ss")
    private String cold_product_time;

    //result
    @ExcelProperty("钢种")
    @ColumnWidth(20)
    private String steelgrade;//钢种

    @ExcelProperty("含硅量")
    @ColumnWidth(20)
    private Double ele_si;//含硅量

    @ExcelProperty("产品厚度")
    @ColumnWidth(20)
    private Double ex_thk;//产品厚度

    @ExcelProperty("产品宽度")
    @ColumnWidth(20)
    private Double ex_wid;//产品宽度

    @ExcelProperty("原料厚度")
    @ColumnWidth(20)
    private Double en_thk;//原料厚度

    @ExcelProperty("原料宽度")
    @ColumnWidth(20)
    private Double en_wid;//原料宽度


    @ExcelProperty("边降等级1绝对长度")
    @ColumnWidth(20)
    private Double edge_a_abs_len;//边降等级1绝对长度

    @ExcelProperty("边降等级2绝对长度")
    @ColumnWidth(20)
    private Double edge_b_abs_len;//边降等级2绝对长度

    @ExcelProperty("边降等级3绝对长度")
    @ColumnWidth(20)
    private Double edge_c_abs_len;//边降等级3绝对长度

    @ExcelProperty("边降等级4绝对长度")
    @ColumnWidth(20)
    private Double edge_d_abs_len;//边降等级4绝对长度

    @ExcelProperty("边降等级5绝对长度")
    @ColumnWidth(20)
    private Double edge_e_abs_len;//边降等级5绝对长度


    @ExcelProperty("边降等级1相对长度")
    @ColumnWidth(20)
    private Double edge_a_rel_len;//边降等级1相对长度

    @ExcelProperty("边降等级2相对长度")
    @ColumnWidth(20)
    private Double edge_b_rel_len;//边降等级2相对长度

    @ExcelProperty("边降等级3相对长度")
    @ColumnWidth(20)
    private Double edge_c_rel_len;//边降等级3相对长度

    @ExcelProperty("边降等级4相对长度")
    @ColumnWidth(20)
    private Double edge_d_rel_len;//边降等级4相对长度

    @ExcelProperty("边降等级5相对长度")
    @ColumnWidth(20)
    private Double edge_e_rel_len;//边降等级5相对长度

    @ExcelProperty("DS边降")
    @ColumnWidth(20)
    private Double edm_ds_avg;

    @ExcelProperty("WS边降")
    @ColumnWidth(20)
    private Double edm_ws_avg;

    @ExcelProperty("DS同板差5")
    @ColumnWidth(20)
    private Double sameplate5_ds_avg;

    @ExcelProperty("WS同板差5")
    @ColumnWidth(20)
    private Double sameplate5_ws_avg;

    @ExcelProperty("DS同板差10")
    @ColumnWidth(20)
    private Double sameplate10_ds_avg;

    @ExcelProperty("WS同板差10")
    @ColumnWidth(20)
    private Double sameplate10_ws_avg;

    @ExcelProperty("DS同板差15")
    @ColumnWidth(20)
    private Double sameplate15_ds_avg;

    @ExcelProperty("WS同板差15")
    @ColumnWidth(20)
    private Double sameplate15_ws_avg;
    
}
